package Modelo;

public class PsPersDataEFFDT extends BaseModelo
{
  private static String tableName = "PS_PERS_DATA_EFFDT";
  private static EstructuraFila estructuraFila = new EstructuraFila();

  public static void setEstructuraFila(EstructuraFila aEstructuraFila)
  {
    estructuraFila = aEstructuraFila;
  }

  public static String getTableName()
  {
    return tableName;
  }

  public static EstructuraFila getEstructuraFila()
  {
    return estructuraFila;
  }

  public PsPersDataEFFDT(String emplid)
  {
    blanquearCamposObligatorios(estructuraFila);

    setEmplid(emplid);
    setUpdate_pers_data("N");
    setCountry("COL");
    setCity("Santiago de Cali");
    setState("1");
    setMar_status("S");
    setSmoker("N");
    setCountry_nm_format("COL");
    setName("Desconocido,DESCONOCIDO");
    setName_prefix("M");
    setLast_name_srch("DESCONOCIDO");
    setFirst_name_srch("DESCONOCIDO");
    setLast_name("Desconocido");
    setFirst_name("Desconocido");
  }

  public void setEmplid(String emplid) {
    asignarCampo("EMPLID", emplid);
  }

  public void setEffdt(String effdt) {
    asignarCampo("EFFDT", "TO_CHAR(" + effdt + " ,'DD-MON-RRRR')");
  }

  public void setUpdate_pers_data(String update_pers_data) {
    asignarCampo("UPDATE_PERS_DATA", update_pers_data);
  }

  public void setCountry(String country) {
    asignarCampo("COUNTRY", country);
  }

  public void setAddress1(String address1) {
    asignarCampo("ADDRESS1", address1);
  }

  public void setAddress2(String address2) {
    asignarCampo("ADDRESS2", address2);
  }

  public void setAddress3(String address3) {
    asignarCampo("ADDRESS3", address3);
  }

  public void setAddress4(String address4) {
    asignarCampo("ADDRESS4", address4);
  }

  public void setCity(String city) {
    asignarCampo("CITY", city);
  }

  public void setNum1(String num1) {
    asignarCampo("NUM1", num1);
  }

  public void setNum2(String num2) {
    asignarCampo("NUM2", num2);
  }

  public void setHouse_type(String house_type) {
    asignarCampo("HOUSE_TYPE", house_type);
  }

  public void setAddr_field1(String addr_field1) {
    asignarCampo("ADDR_FIELD1", addr_field1);
  }

  public void setAddr_field2(String addr_field2) {
    asignarCampo("ADDR_FIELD2", addr_field2);
  }

  public void setAddr_field3(String addr_field3) {
    asignarCampo("ADDR_FIELD3", addr_field3);
  }

  public void setCounty(String county) {
    asignarCampo("COUNTY", county);
  }

  public void setState(String state) {
    asignarCampo("STATE", state);
  }

  public void setPostal(String postal) {
    asignarCampo("POSTAL", postal);
  }

  public void setGeo_code(String geo_code) {
    asignarCampo("GEO_CODE", geo_code);
  }

  public void setIn_city_limit(String in_city_limit) {
    asignarCampo("IN_CITY_LIMIT", in_city_limit);
  }

  public void setAddress1_ac(String address1_ac) {
    asignarCampo("ADDRESS1_AC", address1_ac);
  }

  public void setAddress2_ac(String address2_ac) {
    asignarCampo("ADDRESS2_AC", address2_ac);
  }

  public void setAddress3_ac(String address3_ac) {
    asignarCampo("ADDRESS3_AC", address3_ac);
  }

  public void setCity_ac(String city_ac) {
    asignarCampo("CITY_AC", city_ac);
  }

  public void setCountry_other(String country_other) {
    asignarCampo("COUNTRY_OTHER", country_other);
  }

  public void setAddress1_other(String address1_other) {
    asignarCampo("ADDRESS1_OTHER", address1_other);
  }

  public void setAddress2_other(String address2_other) {
    asignarCampo("ADDRESS2_OTHER", address2_other);
  }

  public void setAddress3_other(String address3_other) {
    asignarCampo("ADDRESS3_OTHER", address3_other);
  }

  public void setAddress4_other(String address4_other) {
    asignarCampo("ADDRESS4_OTHER", address4_other);
  }

  public void setCity_other(String city_other) {
    asignarCampo("CITY_OTHER", city_other);
  }

  public void setCounty_other(String county_other) {
    asignarCampo("COUNTY_OTHER", county_other);
  }

  public void setState_other(String state_other) {
    asignarCampo("STATE_OTHER", state_other);
  }

  public void setPostal_other(String postal_other) {
    asignarCampo("POSTAL_OTHER", postal_other);
  }

  public void setNum1_other(String num1_other) {
    asignarCampo("NUM1_OTHER", num1_other);
  }

  public void setNum2_other(String num2_other) {
    asignarCampo("NUM2_OTHER", num2_other);
  }

  public void setHouse_type_other(String house_type_other) {
    asignarCampo("HOUSE_TYPE_OTHER", house_type_other);
  }

  public void setAddr_field1_other(String addr_field1_other) {
    asignarCampo("ADDR_FIELD1_OTHER", addr_field1_other);
  }

  public void setAddr_field2_other(String addr_field2_other) {
    asignarCampo("ADDR_FIELD2_OTHER", addr_field2_other);
  }

  public void setAddr_field3_other(String addr_field3_other) {
    asignarCampo("ADDR_FIELD3_OTHER", addr_field3_other);
  }

  public void setIn_city_lmt_other(String in_city_lmt_other) {
    asignarCampo("IN_CITY_LMT_OTHER", in_city_lmt_other);
  }

  public void setGeo_code_other(String geo_code_other) {
    asignarCampo("GEO_CODE_OTHER", geo_code_other);
  }

  public void setMar_status(String mar_status) {
    asignarCampo("MAR_STATUS", mar_status);
  }

  public void setSmoker(String smoker) {
    asignarCampo("SMOKER", smoker);
  }

  public void setCountry_nm_format(String country_nm_format) {
    asignarCampo("COUNTRY_NM_FORMAT", country_nm_format);
  }

  public void setName(String name) {
    asignarCampo("NAME", name);
  }

  public void setName_initials(String name_initials) {
    asignarCampo("NAME_INITIALS", name_initials);
  }

  public void setName_prefix(String name_prefix) {
    asignarCampo("NAME_PREFIX", name_prefix);
  }

  public void setName_suffix(String name_suffix) {
    asignarCampo("NAME_SUFFIX", name_suffix);
  }

  public void setName_royal_prefix(String name_royal_prefix) {
    asignarCampo("NAME_ROYAL_PREFIX", name_royal_prefix);
  }

  public void setName_royal_suffix(String name_royal_suffix) {
    asignarCampo("NAME_ROYAL_SUFFIX", name_royal_suffix);
  }

  public void setName_title(String name_title) {
    asignarCampo("NAME_TITLE", name_title);
  }

  public void setLast_name_srch(String last_name_srch) {
    asignarCampo("LAST_NAME_SRCH", last_name_srch);
  }

  public void setFirst_name_srch(String first_name_srch) {
    asignarCampo("FIRST_NAME_SRCH", first_name_srch);
  }

  public void setLast_name(String last_name) {
    asignarCampo("LAST_NAME", last_name);
  }

  public void setFirst_name(String first_name) {
    asignarCampo("FIRST_NAME", first_name);
  }

  public void setMiddle_name(String middle_name) {
    asignarCampo("MIDDLE_NAME", middle_name);
  }

  public void setSecond_last_name(String second_last_name) {
    asignarCampo("SECOND_LAST_NAME", second_last_name);
  }

  public void setSecond_last_srch(String second_last_srch) {
    asignarCampo("SECOND_LAST_SRCH", second_last_srch);
  }

  public void setName_ac(String name_ac) {
    asignarCampo("NAME_AC", name_ac);
  }

  public void setPref_first_name(String pref_first_name) {
    asignarCampo("PREF_FIRST_NAME", pref_first_name);
  }

  public AtributoValor getEmplid()
  {
    return obtenerAtributoValor("EMPLID");
  }

  public AtributoValor getEffdt() {
    return obtenerAtributoValor("EFFDT");
  }

  public AtributoValor getUpdate_pers_data() {
    return obtenerAtributoValor("UPDATE_PERS_DATA");
  }

  public AtributoValor getCountry() {
    return obtenerAtributoValor("COUNTRY");
  }

  public AtributoValor getAddress1() {
    return obtenerAtributoValor("ADDRESS1");
  }

  public AtributoValor getAddress2() {
    return obtenerAtributoValor("ADDRESS2");
  }

  public AtributoValor getAddress3() {
    return obtenerAtributoValor("ADDRESS3");
  }

  public AtributoValor getAddress4() {
    return obtenerAtributoValor("ADDRESS4");
  }

  public AtributoValor getCity() {
    return obtenerAtributoValor("CITY");
  }

  public AtributoValor getNum1() {
    return obtenerAtributoValor("NUM1");
  }

  public AtributoValor getNum2() {
    return obtenerAtributoValor("NUM2");
  }

  public AtributoValor getHouse_type() {
    return obtenerAtributoValor("HOUSE_TYPE");
  }

  public AtributoValor getAddr_field1() {
    return obtenerAtributoValor("ADDR_FIELD1");
  }

  public AtributoValor getAddr_field2() {
    return obtenerAtributoValor("ADDR_FIELD2");
  }

  public AtributoValor getAddr_field3() {
    return obtenerAtributoValor("ADDR_FIELD3");
  }

  public AtributoValor getCounty() {
    return obtenerAtributoValor("COUNTY");
  }

  public AtributoValor getState() {
    return obtenerAtributoValor("STATE");
  }

  public AtributoValor getPostal() {
    return obtenerAtributoValor("POSTAL");
  }

  public AtributoValor getGeo_code() {
    return obtenerAtributoValor("GEO_CODE");
  }

  public AtributoValor getIn_city_limit() {
    return obtenerAtributoValor("IN_CITY_LIMIT");
  }

  public AtributoValor getAddress1_ac() {
    return obtenerAtributoValor("ADDRESS1_AC");
  }

  public AtributoValor getAddress2_ac() {
    return obtenerAtributoValor("ADDRESS2_AC");
  }

  public AtributoValor getAddress3_ac() {
    return obtenerAtributoValor("ADDRESS3_AC");
  }

  public AtributoValor getCity_ac() {
    return obtenerAtributoValor("CITY_AC");
  }

  public AtributoValor getCountry_other() {
    return obtenerAtributoValor("COUNTRY_OTHER");
  }

  public AtributoValor getAddress1_other() {
    return obtenerAtributoValor("ADDRESS1_OTHER");
  }

  public AtributoValor getAddress2_other() {
    return obtenerAtributoValor("ADDRESS2_OTHER");
  }

  public AtributoValor getAddress3_other() {
    return obtenerAtributoValor("ADDRESS3_OTHER");
  }

  public AtributoValor getAddress4_other() {
    return obtenerAtributoValor("ADDRESS4_OTHER");
  }

  public AtributoValor getCity_other() {
    return obtenerAtributoValor("CITY_OTHER");
  }

  public AtributoValor getCounty_other() {
    return obtenerAtributoValor("COUNTY_OTHER");
  }

  public AtributoValor getState_other() {
    return obtenerAtributoValor("STATE_OTHER");
  }

  public AtributoValor getPostal_other() {
    return obtenerAtributoValor("POSTAL_OTHER");
  }

  public AtributoValor getNum1_other() {
    return obtenerAtributoValor("NUM1_OTHER");
  }

  public AtributoValor getNum2_other() {
    return obtenerAtributoValor("NUM2_OTHER");
  }

  public AtributoValor getHouse_type_other() {
    return obtenerAtributoValor("HOUSE_TYPE_OTHER");
  }

  public AtributoValor getAddr_field1_other() {
    return obtenerAtributoValor("ADDR_FIELD1_OTHER");
  }

  public AtributoValor getAddr_field2_other() {
    return obtenerAtributoValor("ADDR_FIELD2_OTHER");
  }

  public AtributoValor getAddr_field3_other() {
    return obtenerAtributoValor("ADDR_FIELD3_OTHER");
  }

  public AtributoValor getIn_city_lmt_other() {
    return obtenerAtributoValor("IN_CITY_LMT_OTHER");
  }

  public AtributoValor getGeo_code_other() {
    return obtenerAtributoValor("GEO_CODE_OTHER");
  }

  public AtributoValor getMar_status() {
    return obtenerAtributoValor("MAR_STATUS");
  }

  public AtributoValor getSmoker() {
    return obtenerAtributoValor("SMOKER");
  }

  public AtributoValor getCountry_nm_format() {
    return obtenerAtributoValor("COUNTRY_NM_FORMAT");
  }

  public AtributoValor getName() {
    return obtenerAtributoValor("NAME");
  }

  public AtributoValor getName_initials() {
    return obtenerAtributoValor("NAME_INITIALS");
  }

  public AtributoValor getName_prefix() {
    return obtenerAtributoValor("NAME_PREFIX");
  }

  public AtributoValor getName_suffix() {
    return obtenerAtributoValor("NAME_SUFFIX");
  }

  public AtributoValor getName_royal_prefix() {
    return obtenerAtributoValor("NAME_ROYAL_PREFIX");
  }

  public AtributoValor getName_royal_suffix() {
    return obtenerAtributoValor("NAME_ROYAL_SUFFIX");
  }

  public AtributoValor getName_title() {
    return obtenerAtributoValor("NAME_TITLE");
  }

  public AtributoValor getLast_name_srch() {
    return obtenerAtributoValor("LAST_NAME_SRCH");
  }

  public AtributoValor getFirst_name_srch() {
    return obtenerAtributoValor("FIRST_NAME_SRCH");
  }

  public AtributoValor getLast_name() {
    return obtenerAtributoValor("LAST_NAME");
  }

  public AtributoValor getFirst_name() {
    return obtenerAtributoValor("FIRST_NAME");
  }

  public AtributoValor getMiddle_name() {
    return obtenerAtributoValor("MIDDLE_NAME");
  }

  public AtributoValor getSecond_last_name() {
    return obtenerAtributoValor("SECOND_LAST_NAME");
  }

  public AtributoValor getSecond_last_srch() {
    return obtenerAtributoValor("SECOND_LAST_SRCH");
  }

  public AtributoValor getName_ac() {
    return obtenerAtributoValor("NAME_AC");
  }

  public AtributoValor getPref_first_name() {
    return obtenerAtributoValor("PREF_FIRST_NAME");
  }

  static
  {
    estructuraFila.adicionar("EMPLID", "S", true, "getEmplid");
    estructuraFila.adicionar("EFFDT", "D", true, "getEffdt");
    estructuraFila.adicionar("UPDATE_PERS_DATA", "S", true, "getUpdate_pers_data");
    estructuraFila.adicionar("COUNTRY", "S", true, "getCountry");
    estructuraFila.adicionar("ADDRESS1", "S", true, "getAddress1");
    estructuraFila.adicionar("ADDRESS2", "S", true, "getAddress2");
    estructuraFila.adicionar("ADDRESS3", "S", true, "getAddress3");
    estructuraFila.adicionar("ADDRESS4", "S", true, "getAddress4");
    estructuraFila.adicionar("CITY", "S", true, "getCity");
    estructuraFila.adicionar("NUM1", "S", true, "getNum1");
    estructuraFila.adicionar("NUM2", "S", true, "getNum2");
    estructuraFila.adicionar("HOUSE_TYPE", "S", true, "getHouse_type");
    estructuraFila.adicionar("ADDR_FIELD1", "S", true, "getAddr_field1");
    estructuraFila.adicionar("ADDR_FIELD2", "S", true, "getAddr_field2");
    estructuraFila.adicionar("ADDR_FIELD3", "S", true, "getAddr_field3");
    estructuraFila.adicionar("COUNTY", "S", true, "getCounty");
    estructuraFila.adicionar("STATE", "S", true, "getState");
    estructuraFila.adicionar("POSTAL", "S", true, "getPostal");
    estructuraFila.adicionar("GEO_CODE", "S", true, "getGeo_code");
    estructuraFila.adicionar("IN_CITY_LIMIT", "S", true, "getIn_city_limit");
    estructuraFila.adicionar("ADDRESS1_AC", "S", true, "getAddress1_ac");
    estructuraFila.adicionar("ADDRESS2_AC", "S", true, "getAddress2_ac");
    estructuraFila.adicionar("ADDRESS3_AC", "S", true, "getAddress3_ac");
    estructuraFila.adicionar("CITY_AC", "S", true, "getCity_ac");
    estructuraFila.adicionar("COUNTRY_OTHER", "S", true, "getCountry_other");
    estructuraFila.adicionar("ADDRESS1_OTHER", "S", true, "getAddress1_other");
    estructuraFila.adicionar("ADDRESS2_OTHER", "S", true, "getAddress2_other");
    estructuraFila.adicionar("ADDRESS3_OTHER", "S", true, "getAddress3_other");
    estructuraFila.adicionar("ADDRESS4_OTHER", "S", true, "getAddress4_other");
    estructuraFila.adicionar("CITY_OTHER", "S", true, "getCity_other");
    estructuraFila.adicionar("COUNTY_OTHER", "S", true, "getCounty_other");
    estructuraFila.adicionar("STATE_OTHER", "S", true, "getState_other");
    estructuraFila.adicionar("POSTAL_OTHER", "S", true, "getPostal_other");
    estructuraFila.adicionar("NUM1_OTHER", "S", true, "getNum1_other");
    estructuraFila.adicionar("NUM2_OTHER", "S", true, "getNum2_other");
    estructuraFila.adicionar("HOUSE_TYPE_OTHER", "S", true, "getHouse_type_other");
    estructuraFila.adicionar("ADDR_FIELD1_OTHER", "S", true, "getAddr_field1_other");
    estructuraFila.adicionar("ADDR_FIELD2_OTHER", "S", true, "getAddr_field2_other");
    estructuraFila.adicionar("ADDR_FIELD3_OTHER", "S", true, "getAddr_field3_other");
    estructuraFila.adicionar("IN_CITY_LMT_OTHER", "S", true, "getIn_city_lmt_other");
    estructuraFila.adicionar("GEO_CODE_OTHER", "S", true, "getGeo_code_other");
    estructuraFila.adicionar("MAR_STATUS", "S", true, "getMar_status");
    estructuraFila.adicionar("SMOKER", "S", true, "getSmoker");
    estructuraFila.adicionar("COUNTRY_NM_FORMAT", "S", true, "getCountry_nm_format");
    estructuraFila.adicionar("NAME", "S", true, "getName");
    estructuraFila.adicionar("NAME_INITIALS", "S", true, "getName_initials");
    estructuraFila.adicionar("NAME_PREFIX", "S", true, "getName_prefix");
    estructuraFila.adicionar("NAME_SUFFIX", "S", true, "getName_suffix");
    estructuraFila.adicionar("NAME_ROYAL_PREFIX", "S", true, "getName_royal_prefix");
    estructuraFila.adicionar("NAME_ROYAL_SUFFIX", "S", true, "getName_royal_suffix");
    estructuraFila.adicionar("NAME_TITLE", "S", true, "getName_title");
    estructuraFila.adicionar("LAST_NAME_SRCH", "S", true, "getLast_name_srch");
    estructuraFila.adicionar("FIRST_NAME_SRCH", "S", true, "getFirst_name_srch");
    estructuraFila.adicionar("LAST_NAME", "S", true, "getLast_name");
    estructuraFila.adicionar("FIRST_NAME", "S", true, "getFirst_name");
    estructuraFila.adicionar("MIDDLE_NAME", "S", true, "getMiddle_name");
    estructuraFila.adicionar("SECOND_LAST_NAME", "S", true, "getSecond_last_name");
    estructuraFila.adicionar("SECOND_LAST_SRCH", "S", true, "getSecond_last_srch");
    estructuraFila.adicionar("NAME_AC", "S", true, "getName_ac");
    estructuraFila.adicionar("PREF_FIRST_NAME", "S", true, "getPref_first_name");
  }
}